package com.tjetc.dao;

import com.tjetc.domian.Propertyservice;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface PropertyserviceMapper {
    int deleteByPrimaryKey(Integer serviceid);

    int insert(Propertyservice record);

    int insertSelective(Propertyservice record);

    Propertyservice selectByPrimaryKey(Integer serviceid);

    int updateByPrimaryKeySelective(Propertyservice record);

    int updateByPrimaryKey(Propertyservice record);

    @Select("select * from propertyservice")
    List<Propertyservice> select();
@Select("select * from propertyservice where servicename=#{servicename} ")
    Propertyservice findByName(String servicename);
@Select("select * from propertyservice where serviceid= #{serviceid} ")
    boolean findById(int serviceid);
@Update("update propertyservice set servicename=#{servicename},servicetype=#{servicetype},frequency=#{frequency},provider=#{provider} where serviceid=#{serviceid}")
    int updata(Propertyservice propertyservice);
}